importing dbf file

Hi

I am trying to import a DBaseIV *.dbf file which is sent to me from a different database. I need to import this file on monthly basis. When I tried to use import utility from File menu it worked perfectly. I just want to write a code which will do just that. I tried using Tranasfer Database but dont seem to figure out the Database Name as I just have a simple dbf file which I store in C:\Temp folder.

I will appreciate if someone will point me to right direction and will also appreciate if u could also point me to how to export one of my table in the same exact format.

Cheers!
Aqif

Do you know what the name of this simple dbf file is? Where does the dbf file come from?

Also help me with Export

Yes .......

name of file is Temp.dbf
name of folder C:\Temp

I also want to reverse the process by exporting a table in my db called TblExport into a single file called TempEx.dbf

I really appreciate ur efforts regarding that.

Cheers!
Aqif

To import:

DoCmd.TransferDatabase acImport, "Dbase 5.0", "C:\Temp", acTable, TableName1, TableName2

where Tablename1 is the source table and Tablename2 is the destination.

Export :

Same, but acExport instead of acImport